/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package edu.au.uq.datamining.entity;

import java.io.Serializable;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
 *
 * @author oracle
 */
@Entity
@Table(name = "VDATAMART", catalog = "", schema = "FITINT")
@NamedQueries({
    @NamedQuery(name = "Datamart.findAll", query = "SELECT d FROM Datamart d"),
    @NamedQuery(name = "Datamart.findById", query = "SELECT d FROM Datamart d WHERE d.id = :id"),
    @NamedQuery(name = "Datamart.findByLastname", query = "SELECT d FROM Datamart d WHERE d.lastname = :lastname"),
    @NamedQuery(name = "Datamart.findBySecondlastname", query = "SELECT d FROM Datamart d WHERE d.secondlastname = :secondlastname"),
    @NamedQuery(name = "Datamart.findByFirstname", query = "SELECT d FROM Datamart d WHERE d.firstname = :firstname"),
    @NamedQuery(name = "Datamart.findByMiddlename", query = "SELECT d FROM Datamart d WHERE d.middlename = :middlename"),
    @NamedQuery(name = "Datamart.findByGender", query = "SELECT d FROM Datamart d WHERE d.gender = :gender"),
    @NamedQuery(name = "Datamart.findByMaritalstatus", query = "SELECT d FROM Datamart d WHERE d.maritalstatus = :maritalstatus"),
    @NamedQuery(name = "Datamart.findByHousetype", query = "SELECT d FROM Datamart d WHERE d.housetype = :housetype"),
    @NamedQuery(name = "Datamart.findByNationality", query = "SELECT d FROM Datamart d WHERE d.nationality = :nationality"),
    @NamedQuery(name = "Datamart.findByIncome", query = "SELECT d FROM Datamart d WHERE d.income = :income"),
    @NamedQuery(name = "Datamart.findByChild", query = "SELECT d FROM Datamart d WHERE d.child = :child"),
    @NamedQuery(name = "Datamart.findByEducation", query = "SELECT d FROM Datamart d WHERE d.education = :education"),
    @NamedQuery(name = "Datamart.findByWorkforgovernment", query = "SELECT d FROM Datamart d WHERE d.workforgovernment = :workforgovernment"),
    @NamedQuery(name = "Datamart.findByLoan", query = "SELECT d FROM Datamart d WHERE d.loan = :loan")})
public class Datamart implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private int id;
    @Basic(optional = false)
    @Column(name = "LASTNAME", nullable = false, length = 25)
    private String lastname;
    @Column(name = "SECONDLASTNAME", length = 25)
    private String secondlastname;
    @Basic(optional = false)
    @Column(name = "FIRSTNAME", nullable = false, length = 20)
    private String firstname;
    @Column(name = "MIDDLENAME", length = 30)
    private String middlename;
    @Basic(optional = false)
    @Column(name = "GENDER", nullable = false, length = 1)
    private String gender;
    @Basic(optional = false)
    @Column(name = "MARITALSTATUS", nullable = false, length = 20)
    private String maritalstatus;
    @Column(name = "HOUSETYPE", length = 1)
    private String housetype;
    @Column(name = "NATIONALITY", length = 3)
    private String nationality;
    @Column(name = "INCOME", length = 11 )
    private String income;
    @Column(name = "CHILD")
    private Short child;
    @Basic(optional = false)
    @Column(name = "EDUCATION", nullable = false, length = 20)
    private String education;
    @Column(name = "WORKFORGOVERNMENT", length = 1)
    private String workforgovernment;
    @Column(name = "LOAN", length = 20)
    private String loan;

    public Datamart() {
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getLastname() {
        return lastname;
    }

    public void setLastname(String lastname) {
        this.lastname = lastname;
    }

    public String getSecondlastname() {
        return secondlastname;
    }

    public void setSecondlastname(String secondlastname) {
        this.secondlastname = secondlastname;
    }

    public String getFirstname() {
        return firstname;
    }

    public void setFirstname(String firstname) {
        this.firstname = firstname;
    }

    public String getMiddlename() {
        return middlename;
    }

    public void setMiddlename(String middlename) {
        this.middlename = middlename;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public String getMaritalstatus() {
        return maritalstatus;
    }

    public void setMaritalstatus(String maritalstatus) {
        this.maritalstatus = maritalstatus;
    }

    public String getHousetype() {
        return housetype;
    }

    public void setHousetype(String housetype) {
        this.housetype = housetype;
    }

    public String getNationality() {
        return nationality;
    }

    public void setNationality(String nationality) {
        this.nationality = nationality;
    }

    public String getIncome() {
        return income;
    }

    public void setIncome(String income) {
        this.income = income;
    }

    public Short getChild() {
        return child;
    }

    public void setChild(Short child) {
        this.child = child;
    }

    public String getEducation() {
        return education;
    }

    public void setEducation(String education) {
        this.education = education;
    }

    public String getWorkforgovernment() {
        return workforgovernment;
    }

    public void setWorkforgovernment(String workforgovernment) {
        this.workforgovernment = workforgovernment;
    }

    public String getLoan() {
        return loan;
    }

    public void setLoan(String loan) {
        this.loan = loan;
    }
}
